How to: Share a workbook over a network.
Solution:
Select 'Shared Lists...' from the 'File' menu and select 'Allow Multi-User Editing' on the 'Editing' dialog box.
1) Open the workbook to be shared.
2) Select the 'File' menu and select 'Shared Lists...'.
3) Click 'Editing' tab.
4) Select the 'Allow Multi-User Editing' check box.
Allow Multi-User Editing
5) (Optional) Select the 'Show Conflict History' check box.
NOTE: This option records user conflicts and how they are resolved. The conflicts are automatically listed on the last sheet of the workbook.
6) Click 'OK'.
